Used to reduce long references to object type variables
With <expression>
statements
...
Endwith
Parameters
| expression | Must be an object type expression |
Remarks
With...EndWith statements may NOT be nested.
Related
For...In...Next
Example
$oExcel = ObjCreate("Excel.Application")
$oExcel.visible =1
$oExcel.workbooks.add
With $oExcel.activesheet
.cells(2,2).value = 1
.range("A1:B2").clear
Endwith
$oExcel.quit